from django.db import models


# Create your models here.
# 班级模型
class Classes(models.Model):
    # 为班级模型设计字段
    name = models.CharField(max_length=25, unique=True, verbose_name='班级名称')
    slogan = models.CharField(max_length=30, null=True, blank=True, verbose_name='班级口号')
    create_time = models.DateTimeField(auto_now_add=True, verbose_name='创建时间')
    update_time = models.DateTimeField(auto_now=True, verbose_name='修改时间')
    is_delete = models.BooleanField(default=False, verbose_name='逻辑删除')

    class Meta:
        db_table = 'classes'

    def delete(self):
        self.is_delete = True
        self.save()

    def __str__(self):
        return self.name


# 学生模型
class Students(models.Model):
    # 为学生模型设计字段
    SEX_CHOICES = ((0, '女'), (1, '男'))
    name = models.CharField(max_length=10, unique=True, verbose_name='姓名')
    age = models.IntegerField(null=True, blank=True, verbose_name='年龄')
    sex = models.IntegerField(null=True, blank=True, choices=SEX_CHOICES, verbose_name='性别')
    create_time = models.DateTimeField(auto_now_add=True, verbose_name='创建时间')
    update_time = models.DateTimeField(auto_now=True, verbose_name='修改时间')
    is_delete = models.BooleanField(default=False, verbose_name='逻辑删除')
    classes = models.ForeignKey(Classes, on_delete=models.SET_NULL, null=True)

    class Meta:
        db_table = 'students'

    def delete(self):
        self.is_delete = True
        self.save()

